﻿<%@ Page Language="C#"  %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data.SqlClient" %>



    <% SqlConnection con = null;
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString);
      con.Open();
      SqlCommand cmd = new SqlCommand("SELECT * FROM message1 where status_='0'",con);
      
      SqlDataReader dr = cmd.ExecuteReader();
      int i = 0;
      while (dr.Read())
      {
          i = i + 1;
          

         
              
         

         
      }
      Response.Write(i);
      
    
      dr.Close();
      con.Close(); %>


